
************************************************************************************************************
**#							TABLE 1 - SUMMARY STATS
************************************************************************************************************

capture cd "C:\Users\austin.starkweather\Dropbox\Research\CEO Pay Ratio\Analysis"
capture cd "/Users/joshw/CEO Pay Ratio/Analysis/"
use "Data/Temp/dataset_main.dta", clear

*********************
*PANEL A - Components
*********************
tabstat pay_ratio ceo_pay_000s med_pay_000s if(sample_yr==1), by(pr_quint) stat(mean n)
tabstat pay_ratio ceo_pay_000s med_pay_000s if(sample_yr!=1), by(pr_quint) stat(mean n)
tabstat pay_ratio ceo_pay_000s med_pay_000s if(sample_yr==1 & pr_quint>=2 & pr_quint<=4), stat(mean n)
tabstat pay_ratio ceo_pay_000s med_pay_000s if(sample_yr!=1 & pr_quint>=2 & pr_quint<=4), stat(mean n)

*********************
*PANEL B - RY1
*********************
tabstat gd_pay_post_365 ln_prod_post_365 gd_ceodis_post_365 words spin_ind spin_num explain_ind explain_num tout_ind tout_num suppl_ind suppl_num if(sample_yr==1), by(pr_quint) stat(mean n)
tabstat gd_pay_post_365 ln_prod_post_365 gd_ceodis_post_365 words spin_ind spin_num explain_ind explain_num tout_ind tout_num suppl_ind suppl_num if(sample_yr==1 & pr_quint>=2 & pr_quint<=4), stat(mean n)

**************************************************
*Conditional summary stats (untabulated, Sec. 4.1)
**************************************************

*By pay ratio quintile
tabstat spin_num if(sample_yr==1 & spin_ind==1), stat(mean n) by(pr_quint)
tabstat explain_num if(sample_yr==1 & explain_ind==1), stat(mean n)  by(pr_quint)
tabstat tout_num if(sample_yr==1 & tout_ind==1), stat(mean n) by(pr_quint)
tabstat suppl_num if(sample_yr==1 & suppl_ind==1), stat(mean n) by(pr_quint)

*Pay ratio quintiles 2-4
tabstat spin_num if(sample_yr==1 & spin_ind==1 & pr_quint>=2 & pr_quint<=4), stat(mean n)
tabstat explain_num if(sample_yr==1 & explain_ind==1 & pr_quint>=2 & pr_quint<=4), stat(mean n)  
tabstat tout_num if(sample_yr==1 & tout_ind==1 & pr_quint>=2 & pr_quint<=4), stat(mean n) 
tabstat suppl_num if(sample_yr==1 & suppl_ind==1 & pr_quint>=2 & pr_quint<=4), stat(mean n) 
